<?php
############## DIT STUK CODE ZORGT ERVOOR DAT JE ALS ADMIN INGELOGD MOET ZIJN OM DE PAGINA TE KUNNEN ZIEN ##############

    //Start de sessie
    session_start();

    //Load de benodigde bestanden
    require_once("includes/auth.php");
########################################################################################################################
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <title>Klanten beheren</title>
  <link type="text/css" href="../css/pagination.css" rel="stylesheet" />
  <link rel="stylesheet" href="../css/reset.css" type="text/css" />
  <link rel="stylesheet" href="../css/960.css" type="text/css" />
  <link rel="stylesheet" href="../css/text.css" type="text/css" />
  <link type="text/css" href="../css/tablesorter.css" rel="stylesheet" />
  <link type="text/css" href="../css/pager.css" rel="stylesheet" />
  <link type="text/css" href="../css/sunny/jquery-ui-1.8.custom.css" rel="stylesheet" />
  <link type="text/css" href="../css/jquery.autocomplete.css" rel="stylesheet" />
  <link type="text/css" href="../css/style.css" rel="stylesheet" />
  <link type="text/css" href="../css/accmenu.css" rel="stylesheet" />
<script type="text/javascript" src="../js/jquery-1.4.2.min.js">
</script>
<script type="text/javascript" src="../js/jquery-ui-1.8.custom.min.js">
</script>
<script type="text/javascript" src="../js/jquery.tablesorter.js">
</script>
<script type="text/javascript" src="../js/jquery.tablesorter.pager.js">
</script>
<script type="text/javascript" src="../js/jquery.autocomplete.min.js">
</script>
<script type="text/javascript" src="../js/menu.js">
</script>
<script type="text/javascript">
$(document).ready(function()
    {
        $("#custtable")
            .tablesorter()
            .tablesorterPager({container: $("#pager"), positionFixed: false});
    }
);
</script>

</head>
<body>
<div class="container_12">
<div id="header" class="grid_12">


</div>
<div class="clear"></div>
<div class="grid_12 spacer"></div>
<div class="clear"></div>
<div id="menu" class="grid_2">

        <?php
        include_once 'temp/menu_filler.php';
        ?>


</div>
<div id="adminarea" class="grid_10">
        <div id="tableholder">
			<?php
                include('includes/connect.php');	// include your code to connect to DB.

                $tbl_name="klant";

                $sql = "SELECT klantid, voornaam, tussenvoegsel, achternaam FROM klant ORDER BY achternaam ASC";
                $result = mysql_query($sql);

                echo "<table class='tablesorter' id='custtable' border='1'>";
                echo "<thead><tr> <th>Klant ID</th> <th>Naam</th> <th>Bewerken</th> <th>Verwijderen</th> </tr></thead>";
                echo "<tbody>";
                // keeps getting the next row until there are no more to get
                while ($row = mysql_fetch_array($result)) {

                $id=$row['klantid'];
                $naam=$row['voornaam']." ".$row['tussenvoegsel']." ".$row['achternaam'];

                // Print out the contents of each row into a table
                echo    "<tr><td>".$id;
                echo    "</td><td>".$naam.
                        "</td><td>".
                        "<a href='edit_cust.php?id=$id'>Bewerken</a>";
                echo    "</td><td>".
                        "<a href='del_cust.php?id=$id' onclick=\"return confirm('Weet u zeker dat u dit wilt doen?')\">Verwijderen</a>".
                        "</td></tr>";

                }
                echo    "</tbody>".
                        "</table>";
            ?>
            <center><div id="pager" class="pager">
            	<form>
            		<img src="../css/icons/first.png" class="first"/>
            		<img src="../css/icons/prev.png" class="prev"/>
            		<input type="text" class="pagedisplay"/>
            		<img src="../css/icons/next.png" class="next"/>
            		<img src="../css/icons/last.png" class="last"/>
            		<select class="pagesize">
            			<option value="5">5</option>
            			<option selected="selected" value="10">10</option>
            		</select>
            	</form>
            </div></center>
        </div>

</div>
<div class="clear"></div>
<div class="grid_12 spacer"></div>
<div class="clear"></div>
</div>
</body>
</html>